package com.ahzy.mapper;


import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.ahzy.po.Comment;
import com.ahzy.vo.CommentAndUser;

@Repository
public interface CommentMapper extends BaseMapper<Comment> {
	
	@Select("SELECT * FROM comment c LEFT JOIN user u ON c.uid = u.id  WHERE c.nid = #{nid, jdbcType=INTEGER}")
    List<CommentAndUser> selectByUserAndCommentExamplePage(Integer nid);

}